package com.ihrm.dao;

import com.ihrm.domain.employee.EmployeeReportResult;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 数据访问接口
 */
@Mapper
public interface UserCompanyPersonalDao{

    @Select("select * from em_user_company_personal a left join em_resignation b on a.user_id = b.user_id where a.time_of_entry like CONCAT( #{month},'%') or b.resignation_time like CONCAT( #{month},'%')")
    List<EmployeeReportResult> findByReport(String month);
}
